﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="administration.aspx.vb" Inherits="Fruiterie_Atwater.produitTestListView" MasterPageFile="~/fruiterieAtwaterMP.Master"%>

<asp:Content ID="test" runat="server" ContentPlaceHolderID="ContentPlaceHolderFruiterie_Atwater">
         <asp:Label ID="Label2" runat="server" Text="Gestion des Produits"></asp:Label>
         <hr />
         <br /><br />
    <asp:Label ID="Label1" runat="server" Text="filtrer par categorie"></asp:Label>
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
        DataSourceID="CategorieDataSource" DataTextField="description" 
        DataValueField="noCategorie">
    </asp:DropDownList>
    <div>
    
    </div>

    <!-- ********************************************Produits***********************************************-->

    <asp:ListView ID="ListView1" runat="server" DataKeyNames="noProduit" 
        DataSourceID="LinqDataSource1" InsertItemPosition="LastItem" 
        style="margin-left: 96px; margin-right: 0px" ClientIDMode="Static">
        <AlternatingItemTemplate>
            <tr style="background-color:#FFF8DC;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                        Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                
                <td>
                    <asp:Label ID="Label4" runat="server" 
                        Text='<%# Eval("description") %>' />
                </td>           
               
                <td>
                    <asp:Label ID="prixCoutantLabel" runat="server" 
                        Text='<%# Eval("prixCoutant") %>' />
                </td>
                
                <td>
                    <asp:Label ID="prixVenduLabel" runat="server" 
                        Text='<%# Eval("prixVendu") %>' />
                </td>
                
                <td>
                    <asp:Label ID="qteProduitLabel" runat="server" 
                        Text='<%# Eval("qteProduit") %>' />
                </td>
                <td>
                   <!--<asp:Label ID="noCategorieLabel" runat="server" 
                        Text='<%# Eval("noCategorie") %>' />--> 
                   
                            <%# Eval("category.description")%>
                       
                    
                        
                    
                </td>
               
                
            </tr>
        </AlternatingItemTemplate>
        <EditItemTemplate>
            <tr style="background-color:#008A8C;color: #FFFFFF;">
                <td>
                    <asp:Button ID="UpdateButton" runat="server" CommandName="Update" 
                        Text="Update" />
                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                        Text="Cancel" />
                </td>
                <td>
                    <asp:TextBox ID="descriptionTextBox1" runat="server" 
                        Text='<%# Bind("description") %>' />
                    
                </td>
                <td>
                  
                    <asp:TextBox ID="prixCoutantTextBox1" runat="server" 
                        Text='<%# Bind("prixCoutant") %>' />
                    <asp:RegularExpressionValidator ID="revDigits1" runat="server" ControlToValidate="prixCoutantTextBox1"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                <td>
                    <asp:TextBox ID="prixVenduTextBox1" runat="server" 
                        Text='<%# Bind("prixVendu") %>' />
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="prixVenduTextBox1"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                
                <td>
                    <asp:TextBox ID="qteProduitTextBox1" runat="server" 
                        Text='<%# Bind("qteProduit") %>' />
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="qteProduitTextBox1"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                <td>
                    <!-- <asp:TextBox ID="noCategorieTextBox" runat="server" 
                        Text='<%# Bind("noCategorie") %>' /> -->
                
                            <%# Eval("category.description")%>
                      
                       
                            <asp:DropDownList ID="ddlFournisseurs" runat="server"
                            DataSourceID="CategorieDataSource"
                            DataTextField="description"
                            DataValueField="noCategorie"
                            SelectedValue='<%# Bind("noCategorie") %>'>
                            </asp:DropDownList>
                   
                </td>
                
                
            </tr>
        </EditItemTemplate>
        <EmptyDataTemplate>
            <table runat="server" 
                
                style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
                <tr>
                    <td>
                        No data was returned.</td>
                </tr>
            </table>
        </EmptyDataTemplate>
        <InsertItemTemplate>
            <tr style="">
                <td>
                    <asp:Button ID="InsertButton" runat="server" CommandName="Insert" 
                        Text="Insert" />
                    <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                        Text="Clear" />
                </td>
                
                
                <td>
                    <asp:TextBox ID="descriptionTextBox" runat="server" 
                        Text='<%# Bind("description") %>' />  
                </td>
                <td>
                  
                    <asp:TextBox ID="prixCoutantTextBox" runat="server" 
                        Text='<%# Bind("prixCoutant") %>' />
                    <asp:RegularExpressionValidator ID="revDigits" runat="server" ControlToValidate="prixCoutantTextBox"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                <td>
                    <asp:TextBox ID="prixVenduTextBox" runat="server" 
                        Text='<%# Bind("prixVendu") %>' />
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" ControlToValidate="prixVenduTextBox"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                
                <td>
                    <asp:TextBox ID="qteProduitTextBox" runat="server" 
                        Text='<%# Bind("qteProduit") %>' />
                    <asp:RegularExpressionValidator ID="RegularExpressionValidator4" runat="server" ControlToValidate="qteProduitTextBox"
                ErrorMessage="Input a digits number, please!" Text="*" ForeColor="red" ValidationExpression="^(-?\d+)(\.\d+)?$"></asp:RegularExpressionValidator>   
                </td>
                <td>
                     <%# Eval("category.description")%>
                        
                       
                            <asp:DropDownList ID="ddlFournisseurs" runat="server"
                            DataSourceID="CategorieDataSource"
                            DataTextField="description"
                            DataValueField="noCategorie"
                            SelectedValue='<%# Bind("noCategorie") %>'>
                            </asp:DropDownList>
                        
                    
                </td>
                
                
            </tr>
        </InsertItemTemplate>
        <ItemTemplate>
            <tr style="background-color:#DCDCDC;color: #000000;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                        Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                
                <td>
                    <asp:Label ID="descriptionLabel" runat="server" 
                        Text='<%# Eval("description") %>' />
                </td>
                <td>
                    <asp:Label ID="prixCoutantLabel" runat="server" 
                        Text='<%# Eval("prixCoutant") %>' />
                </td>
                <td>
                    <asp:Label ID="prixVenduLabel" runat="server" 
                        Text='<%# Eval("prixVendu") %>' />
                </td>
                
                <td>
                    <asp:Label ID="qteProduitLabel" runat="server" 
                        Text='<%# Eval("qteProduit") %>' />
                </td>
                <td>
                <!--
                    <asp:Label ID="noCategorieLabel" runat="server" 
                        Text='<%# Eval("noCategorie") %>' />
                        -->
                        

                          <%# Eval("category.description")%>
  
                        <!--
                        <EditItemTemplate>
                            <asp:DropDownList ID="ddlFournisseurs" runat="server"
                            DataSourceID="CategorieDataSource"
                            DataTextField="description"
                            DataValueField="noCategorie"
                            SelectedValue='<%# Bind("noCategorie") %>'>
                            </asp:DropDownList>
                        </EditItemTemplate>
                        -->
                </td>
                
                
            </tr>
        </ItemTemplate>
        
        <LayoutTemplate>
            <table runat="server">
                <tr runat="server">
                    <td runat="server">
                        <table ID="itemPlaceholderContainer" runat="server" border="1" 
                            
                            style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
                            <tr runat="server" style="background-color:#DCDCDC;color: #000000;">
                                <th runat="server">
                                </th>
                                
                                <th runat="server">
                                    description</th>
                                <th runat="server">
                                    prixCoutant</th>
                                <th runat="server">
                                    prixVendu</th>
  
                                <th runat="server">
                                    qteProduit</th>
                                <th runat="server">
                                    Catégorie</th>
                               
  
                            </tr>
                            <tr ID="itemPlaceholder" runat="server">
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr runat="server">
                    <td runat="server" 
                        
                        style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
                        <asp:DataPager ID="DataPager1" runat="server">
                            <Fields>
                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" 
                                    ShowLastPageButton="True" />
                            </Fields>
                        </asp:DataPager>
                    </td>
                </tr>
            </table>
        </LayoutTemplate>
        <SelectedItemTemplate>
            <tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
                <td>
                    <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                        Text="Delete" />
                    <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                </td>
                
                
                <td>
                    <asp:Label ID="noProduitLabel" runat="server" 
                        Text='<%# Eval("noProduit") %>' />
                </td>
                <td>
                    <asp:Label ID="descriptionLabel" runat="server" 
                        Text='<%# Eval("description") %>' />
                </td>
                <td>
                    <asp:Label ID="prixCoutantLabel" runat="server" 
                        Text='<%# Eval("prixCoutant") %>' />
                </td>
                

                <td>
                    <asp:Label ID="prixVenduLabel" runat="server" 
                        Text='<%# Eval("prixVendu") %>' />
                </td>
               
                <td>
                    <asp:Label ID="qteProduitLabel" runat="server" 
                        Text='<%# Eval("qteProduit") %>' />
                </td>
                

                <td>
                    <asp:Label ID="noCategorieLabel" runat="server" 
                        Text='<%# Eval("noCategorie") %>' />
                </td>
                <td>
                    <asp:Label ID="commandesLabel" runat="server" Text='<%# Eval("commandes") %>' />
                </td>
                <td>
                    <asp:Label ID="categoryLabel" runat="server" Text='<%# Eval("category") %>' />
                </td>
                

            </tr>
        </SelectedItemTemplate>
    </asp:ListView>


<!-- ********************************************Categorie***********************************************-->


    <br /><br />
    <asp:Label ID="Label3" runat="server" Text="Gestion des Catégories"></asp:Label>

         <hr />

    <asp:LinqDataSource ID="LinqDataSource1" runat="server" 
        ContextTypeName="Fruiterie_Atwater.dbEpicerieDataContext" EnableDelete="True" 
        EnableInsert="True" EnableUpdate="True" EntityTypeName="" OrderBy="noCategorie" 
        TableName="produits"
        where="noCategorie=@filtreCat">
        <WhereParameters>
         <asp:ControlParameter Name="filtreCat" DefaultValue="0" ControlID="DropDownList1" PropertyName="SelectedValue" Type="Int32" />
        </WhereParameters>
    </asp:LinqDataSource>
    <asp:LinqDataSource ID="CategorieDataSource" runat="server" 
        ContextTypeName="Fruiterie_Atwater.dbEpicerieDataContext" EntityTypeName="" 
        Select="new (noCategorie, description)" TableName="categories">
    </asp:LinqDataSource>
         <asp:ListView ID="ListView2" runat="server" DataKeyNames="noCategorie" 
             DataSourceID="LinqDataSource3" InsertItemPosition="LastItem" 
             ClientIDMode="Static" >
             <AlternatingItemTemplate>
                 <tr style="background-color:#FFF8DC;">
                     <td>
                         <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                             Text="Delete" />
                         <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                     </td>
                     
                     <td>
                         <asp:Label ID="descriptionLabel" runat="server" 
                             Text='<%# Eval("description") %>' />
                     </td>
                     <td>
                         <img src="<%# Eval("image") %>" alt="photo de categorie" />
                     </td>
                     
                 </tr>
             </AlternatingItemTemplate>
             <EditItemTemplate>
                 <tr style="background-color:#008A8C;color: #FFFFFF;">
                     <td>
                         <asp:Button ID="UpdateButton" runat="server" CommandName="Update" 
                             Text="Update" />
                         <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" 
                             Text="Cancel" />
                     </td>
                    
                     <td>
                         <asp:TextBox ID="descriptionTextBox3" runat="server" 
                             Text='<%# Bind("description") %>' />
                         <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="La descripton ne peut pas être vide" ControlToValidate="descriptionTextBox3" ID="RequiredFieldValidator11" runat="server"></asp:RequiredFieldValidator>
                     </td>
                     <td>
                        <asp:FileUpload id="FileUpload1"                 
                            runat="server">
                        </asp:FileUpload>
                        <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="L'image ne peut pas être vide" ControlToValidate="FileUpload1" ID="RequiredFieldValidator2" runat="server"></asp:RequiredFieldValidator>
                     </td>
                     
                 </tr>
             </EditItemTemplate>
             <EmptyDataTemplate>
                 <table runat="server" 
                     style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
                     <tr>
                         <td>
                             Aucune Donnée retournée.</td>
                     </tr>
                 </table>
             </EmptyDataTemplate>
             <InsertItemTemplate>
                 <tr style="">
                     <td>
                         <asp:Button ID="InsertButton" runat="server" CommandName="Insert" 
                             Text="Insert" />
                     </td>
                     
                     <td>
                         <asp:TextBox ID="descriptionTextBox1" runat="server"
                             Text='<%# Bind("description") %>' />
                     </td>
                     <td>
                        <asp:FileUpload id="FileUpload2"                 
                            runat="server">
                        </asp:FileUpload>
                     </td>
                     
                 </tr>
                        
             </InsertItemTemplate>
             <ItemTemplate>
                 <tr style="background-color:#DCDCDC;color: #000000;">
                     <td>
                         <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                             Text="Delete" />
                         <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                     </td>
                     
                     <td>
                         <asp:Label ID="descriptionLabel" runat="server" 
                             Text='<%# Eval("description") %>' />
                     </td>
                     <td>
                         <img src="<%# Eval("image") %>" height="50px" alt="photo de categorie" />
                     </td>
                    
                 </tr>
             </ItemTemplate>
             <EmptyDataTemplate >
             Oh non cest vide.
             </EmptyDataTemplate>
             <EmptyItemTemplate>
             <td runat="server">
             </td>
             </EmptyItemTemplate>
             <LayoutTemplate>
                 <table runat="server">
                     <tr runat="server">
                         <td runat="server">
                             <table ID="itemPlaceholderContainer" runat="server" border="1" 
                                 style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
                                 <tr runat="server" style="background-color:#DCDCDC;color: #000000;">
                                     <th runat="server">
                                     </th>
                                     
                                     <th runat="server">
                                         description</th>
                                     <th runat="server">
                                         image</th>
                                     
                                 </tr>
                                 <tr ID="itemPlaceholder" runat="server">
                                 </tr>
                             </table>
                         </td>
                     </tr>
                     <tr runat="server">
                         <td runat="server" 
                             style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
                             <asp:DataPager ID="DataPager1" runat="server">
                                 <Fields>
                                     <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" 
                                         ShowLastPageButton="True" />
                                 </Fields>
                             </asp:DataPager>
                         </td>
                     </tr>
                 </table>
             </LayoutTemplate>
             <SelectedItemTemplate>
                 <tr style="background-color:#008A8C;font-weight: bold;color: #FFFFFF;">
                     <td>
                         <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" 
                             Text="Delete" />
                         <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
                     </td>
                     
                     <td>
                         <asp:Label ID="descriptionLabel" runat="server" 
                             Text='<%# Eval("description") %>' />
                     </td>
                     <td>
                         <img src="<%# Eval("image") %>" alt="photo de categorie" />
                     </td>
                     
                 </tr>
             </SelectedItemTemplate>
             </asp:ListView>

    <!-- ********************************************Client***********************************************-->


         <asp:LinqDataSource ID="LinqDataSource3" runat="server" 
             ContextTypeName="Fruiterie_Atwater.dbEpicerieDataContext" EnableDelete="True" 
             EnableInsert="True" EnableUpdate="True" EntityTypeName="" 
             TableName="categories">
         </asp:LinqDataSource>
    
         <br />
         Gestion des clients<hr />
         <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
             AutoGenerateColumns="False" DataKeyNames="noClient" 
             DataSourceID="LinqDataSource2" Width="945px" AllowSorting="true" 
             EnableViewState="False" >
            <Columns>
            <asp:TemplateField ShowHeader="False">
                <ItemTemplate>
                    <table id="itemPlaceholderContainer">
                        <tr>
                            <td>Nom : </td><td><asp:Label ID="Label1" runat="server" Text='<%# Eval("nomClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Prenom : </td><td><asp:Label ID="Label2" runat="server" Text='<%# Eval("prenomClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>NoCivique : </td><td><asp:Label ID="Label3" runat="server" Text='<%# Eval("noCiviqueClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Rue : </td><td><asp:Label ID="Label5" runat="server" Text='<%# Eval("rueClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Code Postal : </td><td><asp:Label ID="Label6" runat="server" Text='<%# Eval("codePostalClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Ville : </td><td><asp:Label ID="Label7" runat="server" Text='<%# Eval("villeClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Téléphone : </td><td><asp:Label ID="Label8" runat="server" Text='<%# Eval("telephoneClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Courriel : </td><td><asp:Label ID="Label9" runat="server" Text='<%# Eval("courrielClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Password : </td><td><asp:Label ID="Label10" runat="server" Text='<%# Eval("passwordClient") %>'></asp:Label><br /></td>
                        </tr>
                        <tr>
                            <td>Niveau d'access : </td><td><asp:Label ID="Label11" runat="server" Text='<%# Eval("niveauAccess") %>'></asp:Label><br /></td>
                        </tr>
                        </table>
                        <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" CausesValidation="false"/>
                        <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />             
                </ItemTemplate>
                <EditItemTemplate>
                    <table id="itemPlaceholderContainer">
                        <tr>
                            <td>Nom : </td><td><asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("nomClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ nom ne peut pas être vide" ControlToValidate="TextBox1" ID="RequiredFieldValidator1" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Prenom : </td><td><asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("prenomClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ prenom ne peut pas être vide" ControlToValidate="TextBox2" ID="RequiredFieldValidator10" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>NoCivique : </td><td><asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("noCiviqueClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ noCivique ne peut pas être vide" ControlToValidate="TextBox3" ID="RequiredFieldValidator9" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Rue : </td><td><asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("rueClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ rue ne peut pas être vide" ControlToValidate="TextBox5" ID="RequiredFieldValidator8" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Code Postal : </td><td><asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("codePostalClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ code postal ne peut pas être vide" ControlToValidate="TextBox6" ID="RequiredFieldValidator7" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Ville : </td><td><asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("villeClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ ville ne peut pas être vide" ControlToValidate="TextBox7" ID="RequiredFieldValidator6" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Téléphone : </td><td><asp:TextBox ID="TextBox8" runat="server" MaxLength="10" Text='<%# Bind("telephoneClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ telephone ne peut pas être vide" ControlToValidate="TextBox8" ID="RequiredFieldValidator5" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Courriel : </td><td><asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("courrielClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ courriel ne peut pas être vide" ControlToValidate="TextBox9" ID="RequiredFieldValidator4" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Password : </td><td><asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("passwordClient") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le champ password ne peut pas être vide" ControlToValidate="TextBox10" ID="RequiredFieldValidator3" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        <tr>
                            <td>Niveau d'access : </td><td><asp:TextBox ID="TextBox11" runat="server" Text='<%# Bind("niveauAccess") %>'></asp:TextBox>
                            <asp:RequiredFieldValidator Text="*" ForeColor="Red" ErrorMessage="Le Niveau d'access ne peut pas être vide" ControlToValidate="TextBox11" ID="RequiredFieldValidator2" runat="server"></asp:RequiredFieldValidator>
                            <br /></td>
                        </tr>
                        </table>
                        <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
                    </table>
                </EditItemTemplate>
            </asp:TemplateField>
         </Columns>
           
         </asp:GridView>
         <br />
         <asp:LinqDataSource ID="LinqDataSource2" runat="server" 
             ContextTypeName="Fruiterie_Atwater.dbEpicerieDataContext" EnableDelete="True" 
             EnableInsert="True" EnableUpdate="True" EntityTypeName="" TableName="clients">
         </asp:LinqDataSource>

         <br />
    
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" />
             <asp:Label id="UploadStatusLabel" ForeColor="Red"
                   runat="server" >
             </asp:Label>
         <br />
</asp:Content>
